SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_GetRecruitAll]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
	/* SET NOCOUNT ON */
	Select  TOP 5 id, topic, update_time from dbo.JOL_Recruitment 
	WHERE state=1
	 ORDER BY update_time desc
	RETURN


GO
